Model Videos
Video tutorials covering Model topics for Pro users. You can also download sample data that supports the use of those videos from this page.
Model Lite Overview
An overview of the Model Lite interface for non-technical building of ETLs and data models.
Connect to Microsoft OLAP or Tabular
A quick demo on how to connect to Microsoft Analysis Services (OLAP or Tabular).
Connect to a SQL Database
A quick demo on connecting to and querying an existing relational database.
Parent-Child Hierarchies
Build SQL-based Parent-child hierarchies in Model and navigate them in Discover.
Data Statistics and Quality
Review statistics for the columns in a given table and take suggested actions, like adding time intelligence.
Python Data and Stock Charts
Learn how to download stock data in Model and use it to build charts in Discover.
Calculated Columns in Data Flows
Create or manipulate column values, or perform calculations on existing column values.
Virtual Column Aggregation
Extend an original data model with new row-level column calculations that will be appended as new attributes or measures to an existing model.
Unpivot Tool
Use the Unpivot tool to tabularize cross-tabbed data sets so they can be used in the analytics engine properly.
Buiding MS Tabular Models
Use Pyramid to design and build a Microsoft Tabular Model. Then use the model in Discover and Formulate.
Buiding Exasol Models
Use Pyramid to design and build an Exasol database and analytical model. Then use the model in Discover and Formulate.
Master Flows
Use Master Flows to perform complex data cleansing and manipulation in multiple data flows.
Machine Learning
Review how machine learning is used internally in Pyramid and how users can perform machine learning in Pyramid.
Tabular Relationship Editor
Review how the relationship editor improves understanding of relationships in complex models with many tables.
Aggregate Tables
Define “short-cut” aggregate tables of attributes and measures to be used in queries, rather than the formal tables in the “master” semantic model.
Shared Tools
These videos cover tools that work in multiple apps in the application.
Personalized Data Catalogs
See how to customize data models (and associated data catalogs) both as a user and as an admin.
Data Model Validator
Use the validator to ensure that the semantic model in Pyramid is aligned with the target database.
Sample Data
Some of the videos use sample Excel data sets. You can download them here for your own testing: